#import uuid
#unique_id = Field('unique_id','boolean',default=uuid.uuid4(),writable=False,readable=False)

active = Field('active','boolean',default=True,writable=False)

############################
# Record Creation Auditing
############################
# record creation
created_by = Field('created_by',db.auth_user,default=user_id,writable=False)
created_on = Field('created_on','datetime',default=request.now,writable=False)

###############################
# Record Modification Auditing
###############################
#modified_by = Field('modified_by',db.auth_user,default=user_id,update=user_id,writable=False)
#modified_on = Field('modified_on','datetime',default=request.now,update=request.now,writable=False)


###############################
# Record Deletion Auditing
###############################
#
# Enabling this violate the Sarbanes–Oxley Act or other laws concerning data retention
# http://en.wikipedia.org/wiki/Sarbanes%E2%80%93Oxley_Act
# 
#deleted_by = Field('modified_by',db.auth_user,default=user_id,update=user_id,writable=False)
#deleted_on = Field('modified_on','datetime',default=request.now,update=request.now,writable=False)
